FIB Exploration
This document will compare a hard download through the Water Quality Portal’s website to the results from tbeptools::read_importfib(). The same figures and tables are produced for both download sources. They are not presented as separate tabs because that removed the functionality of a table of contents.
Website download
FIB Sampling points
This file contains results from microbiological sampling in the 5 TBEP counties from 1995-2022. We don’t necessarily need to know what the results are, just that they exist. The query from Water Quality Portal was also set to only include stations with at least 10 sampling events. The latest download was performed 1/29/2024 and this is the link to the query.
That download was pre-processed using R/WQP_preprocessing.R to:
- filter out Groundwater samples - only keeping Surface Water.
- only keep sample types Fecal Coliform, Total Coliform, Enterococcus, and E. coli (eliminates DNA-based samples). Total Coliform is in the processed data frame but I am ignoring it in this exploration.
- only keep a small subset of columns relevant to this exploration.
The pre-processing reduced the file size from 167MB to 40MB, and the smaller file is used in this document.
Temporal Heatmaps
For 2 & 3M Classes, within the TBEP boundaries, only.